In this articles describes how to use mysql connection in vb.net. Here I am using ADO.net to connect mysql with vb.net. Add mysql.data reference to the reference folder and use it in your form.
Imports MySql.Data.MySqlClient
Using cn As New MySqlConnection(“ConnectionString”)
cn.Open()
Dim cmd As MySqlCommand =cn.CreateCommand
With cmd
.CommandText = "storeprocedurename"
.CommandType = CommandType.StoredProcedure
.Parameters.AddWithValue("parameter1", parameter1)
.Parameters.AddWithValue("parameter2", parameter2)
.ExecuteNonQuery()
End With
cn.Close()
End Using
ConnectionString refers a connection string in your application.
Post your comments / questions
Recent Article
- Requested setting INSTALLED_APPS, but settings are not configured. You must either define..
- ValueError:All arrays must be of the same length - Python
- Check hostname requires server hostname - SOLVED
- How to restrict access to the page Access only for logged user in Django
- Migration admin.0001_initial is applied before its dependency admin.0001_initial on database default
- Add or change a related_name argument to the definition for 'auth.User.groups' or 'DriverUser.groups'. -Django ERROR
- Addition of two numbers in django python
- The request was aborted: Could not create SSL/TLS secure channel -Error in Asp.net
Related Article